Job Description: Database Developer - Information Technology (IT) - Software Development
Position Overview:
The Database Developer works within the Information Technology department, specifically in the Software Development team. This role primarily focuses on designing, developing, and maintaining databases to support various software applications and systems. The Database Developer collaborates with cross-functional teams to ensure efficient and effective database solutions are implemented.
Responsibilities:
1. Design, develop, and maintain databases, ensuring data integrity, security, and availability.
2. Collaborate with software developers, system analysts, and other stakeholders to understand database requirements and translate them into efficient database structures.
3. Develop and optimize database schemas, tables, views, and stored procedures to support application functionality.
4. Perform data modeling, normalization, and indexing to enhance database performance and scalability.
5. Implement and maintain data migration processes, ensuring seamless transition of data between various systems.
6. Develop and maintain database documentation, including data dictionaries, data flow diagrams, and entity-relationship diagrams.
7. Monitor and optimize database performance by identifying and resolving performance bottlenecks, optimizing queries, and implementing appropriate indexing strategies.
8. Troubleshoot database-related issues, perform root cause analysis, and implement corrective actions.
9. Collaborate with the IT Operations team to ensure database backups, disaster recovery plans, and high availability configurations are in place.
10. Stay up-to-date with emerging database technologies and trends, and proactively recommend improvements to database design and development processes.
Required Skills and Qualifications:
1. Bachelor's degree in Computer Science, Information Systems, or a related field.
2. Minimum of 3 years of experience as a Database Developer or in a similar role.
3. Proficiency in database design, development, and administration, utilizing relational database management systems (RDBMS) such as Oracle, SQL Server, or MySQL.
4. Strong understanding of database concepts, including data modeling, normalization, indexing, and performance optimization.
5. Extensive experience in SQL programming including complex queries, stored procedures, and triggers.
6. Familiarity with database development tools and frameworks, such as Microsoft SQL Server Management Studio or Oracle SQL Developer.
7. Experience in database performance tuning and troubleshooting.
8. Understanding of database security principles and best practices.
9. Excellent problem-solving skills and ability to analyze complex data-related issues.
10. Strong attention to detail and ability to work independently or within a team environment.
11. Effective communication skills, both verbal and written, with the ability to explain technical concepts to non-technical stakeholders.
Note: This job description outlines the primary duties and qualifications required for the role of Database Developer. However, it is not exhaustive and other responsibilities may be assigned as needed.